<?php
session_start();
/*
 * Session variables:
 * $_SESSION['type'] [string] = user type of the logged in user
 * $_SESSION['authorised'] [boolean] = whether or not the current user is logged in
 * $_SESSION['edit_announcement'] = id of the announcement to be edited
 */
if (isset($_SESSION['authorised']) && $_SESSION['authorised'] == true) {
    if (isset($_SESSION['type'])) {
        if ($_SESSION['type'] == 'administrator') {
        	$announcement_id= $_SESSION['edit_announcement'];
        	include('connection.inc');
        	$sql = "SELECT * FROM announcements where announcement_id=$announcement_id";
            $result = pg_query($sql);
            $title= pg_fetch_result($result, 0, 'announcement_title');
            $announcement = pg_fetch_result($result, 0, 'announcement');
        	
?>
            <html xmlns="http://www.w3.org/1999/xhtml">
                <head>
               
                    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
                    <title>Edit Announcement</title>
                    <link href="StyleSheet.css" rel="stylesheet" type="text/css" />
                    <style>
                        .nav {
                            width:210px;
                            height:auto;
                            border:thin solid #09C;

                            margin-left: 10px;
                            text-align : center;}

                        .mainline {
                            width:712px;

                            height:auto;
                            text-align : center;}
                        </style>
                        <script>
					         function LimitText(AId,BId)
					         {
					          var e1 = document.getElementById(AId);
					          var e2 = document.getElementById(BId);
					          var l1 = e1.value.length;
					          (l1 > 1000)?e1.value = e1.value.substring(0,1000):e2.innerHTML = 1000 - l1 
					         }
					      </script>
                    </head>

                    <center>
                        <body bgcolor="#FFFFFF">
                            <div id="wrapper">
                            <div id="header">
    <h1></h1>
    </div>
    
    <div id="header2">
    	<h3></h3>
 	</div>
  

                            <div id="nav">
                              <?php include 'admin_navigation.php';?>
                            </div>
                            
                            <div id="mainline">
                                <h4> Edit Announcement </h4>
                                <div id="body">                                    
                                    <form action="admin_editingannouncement.php" method="post">
                                        <table width="712" cellpadding="2" class="infotable" align="left">
                                           <tr align="left">
                                                <th height="42" scope="row">Announcement Title:</th>
                                                <td>
                                                    <input type="text" size="50" maxlength="100" id="title" name="title" value="<?php echo $title;?>"/>
                                                </td>
                                            </tr>
                                             <tr align="left" valign="top">
                                                <th height="42" scope="row">Announcement:</th>
                                                <td>
	                                                <textarea name="announcement" id="announcement" rows="20" cols="50" onkeyup="LimitText('announcement','cleft')" onblur="LimitText('announcement','cleft')"><?php echo $announcement?></textarea></td>
                                                </td>
                                            </tr>
                                            <tr align="left">
                                                <td></td>
                                                <td><label id="cleft" style="font-size:13">1000</label>
    											    <label style="font-size:12" >Characters Left</label>
	        										<input type = "submit" value ="Submit" /></td>
                                            </tr>
                                        </table>
                                    </form>
                                
                            <p align="justify"><br /></p>
                        </div>

                        <br class="clearfloat"/>
                        <br />

</div>
 <div id="footer">
                            <p align="center">
                                Tutorial Business Manager: info@tbms.com <br />Credits/Engineers: Aquino, Chloebelle; Dela Cruz, Roy Erwin; Maliwanag, Ranyel Bryan; Manzano, Audrey Ann; Ng, Sheila Regine<br />
                                <br />copyright 2011</p>
                        </div>
                        </div>
                    </body>
                </center>
            </html>
<?php
        } elseif ($_SESSION['type'] == 'student') {
            header('Location: student_index.php');
            exit();
        } elseif ($_SESSION['type'] == 'tutor') {
            header('Location: tutor_index.php');
            exit();
        } elseif ($_SESSION['type'] == 'parent') {
            header('Location: parent_index.php');
            exit();
        }
    }
} else {
    header('Location: index.php');
}
?>
